Excel 2013 Pivot Table Data Crunching (MrExcel Library) by Jelen Bill & Alexander Michael
Author:Jelen, Bill & Alexander, Michael [Jelen, Bill]
Language: eng
Format: azw3
Publisher: Pearson Education
Published: 2013-01-07T05:00:00+00:00
Other Benefits of the PowerPivot Data Model in All Editions of Excel
You get a number of other side-effect benefits of running your data through the Data Model:
• Count Distinct becomes a calculation option. This was previously hard to do. Excel tricksters would add a column to the original data that divided the COUNTIF of a field into 1. If a customer showed up five times, the calculation would evaluate to (1/5) or 0.2. They would then add up the five records with 0.2 and to get one unique customer. If you’ve ever gone through this painful process, you will be thrilled to know Count Distinct is two clicks away. Ditto for those of you who wanted a distinct count but could never get it to work.
• You can include filtered items in grand totals. Create a pivot table showing the top ten customers. The grand total has always been just the ten customers you see. Now, you can make that total include all of the small customers who were filtered out of the report. This feature has always been in the Subtotals drop-down on the left side of the Design tab in the ribbon, but it was perpetually grayed out. Run your data through the model, and it becomes available.
• Named sets were introduced in Excel 2010, but only for people with OLAP data. Named sets let you create pivot tables with last year’s actuals and next year’s budget. By taking your data through the PowerPivot engine, you cause named sets to become available.
• If you ever use the GETPIVOTDATA function to extract values from pivot tables, you can save a step and convert your pivot table to Cube formulas. Cut and paste these into any format desired.
Download
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.
Implementing Enterprise Observability for Success by Manisha Agrawal and Karun Krishnannair(7414)
Supercharging Productivity with Trello by Brittany Joiner(6673)
Mastering Tableau 2023 - Fourth Edition by Marleen Meier(6443)
Secrets of the JavaScript Ninja by John Resig Bear Bibeault(6424)
Inkscape by Example by István Szép(6292)
Visualize Complex Processes with Microsoft Visio by David J Parker & Šenaj Lelić(5987)
Build Stunning Real-time VFX with Unreal Engine 5 by Hrishikesh Andurlekar(4990)
Design Made Easy with Inkscape by Christopher Rogers(4643)
Customizing Microsoft Teams by Gopi Kondameda(4181)
Linux Device Driver Development Cookbook by Rodolfo Giometti(3939)
Extending Microsoft Power Apps with Power Apps Component Framework by Danish Naglekar(3770)
Business Intelligence Career Master Plan by Eduardo Chavez & Danny Moncada(3769)
Salesforce Platform Enterprise Architecture - Fourth Edition by Andrew Fawcett(3648)
Pandas Cookbook by Theodore Petrou(3624)
The Tableau Workshop by Sumit Gupta Sylvester Pinto Shweta Sankhe-Savale JC Gillet and Kenneth Michael Cherven(3423)
TCP IP by Todd Lammle(2994)
Drawing Shortcuts: Developing Quick Drawing Skills Using Today's Technology by Leggitt Jim(2924)
Exploring Microsoft Excel's Hidden Treasures by David Ringstrom(2893)
Applied Predictive Modeling by Max Kuhn & Kjell Johnson(2884)
